<?php
set_include_path(get_include_path() .PATH_SEPARATOR. $_SERVER['DOCUMENT_ROOT'] );
// echo get_include_path() . "<br />";
 set_include_path(get_include_path() .PATH_SEPARATOR. $_SERVER['DOCUMENT_ROOT']. "leerwinstmeting/" );
/**
 *
 * Database definition file.
 *
 * @author Arti de Lijser
 * @version 0.1
 */

/* Database inlog gegevens */
define("DB_SERVER", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");
define("DB_NAME", "mvl_test");

/* FILES & PATHS */
define("DIR_ROOT",                              "");
define("DIR_APP",                               DIR_ROOT."app/");
define("DIR_DB",                                DIR_ROOT."db/");
define("DIR_DEFS",                              DIR_ROOT."defs/");
define("DIR_FU",				DIR_ROOT."functie/");
define("DIR_FO",				DIR_ROOT."form/");
define("DIR_GRAPH",				DIR_ROOT."graph/");
define("DIR_HANDELINGEN",                       DIR_ROOT."handelingen/");
define("DIR_CLASSES",                           DIR_APP."classes/");
define("DIR_DB_CLASSES",                        DIR_DB."classes/");
define("DIR_FU_CLASSES",			DIR_FU."classes/");
define("DIR_PRESTATIE",                         DIR_HANDELINGEN."prestatie/");
define("DIR_VERMOGEN",                          DIR_HANDELINGEN."vermogen/");

/* TABLE definitions */
define("TBL_LEGENDA",                           "legenda");
define("TBL_LEGENDATYPE",                       "legenda_type");
define("TBL_LEGENDAITEM",                       "legenda_item");
define("TBL_CONTEXT",                           "context");
define("TBL_COMPLEXITEIT",                      "complexiteit");
define("TBL_INDICATOR",                         "indicator");
define("TBL_TYPE",                              "type");
define("TBL_STATUS_VOLGNUMMER",                 "status_volgnummer");
define("TBL_MEASURE",                           "measure"     );
define("TBL_PRESTATIE",				"prestatie");
define("TBL_VERMOGEN",				"vermogen");
define("TBL_PRESTATIE_HANDELINGEN",             "prestatie_handeling");
define("TBL_VERMOGEN_HANDELINGEN",              "vermogen_handelingen");

/* TBL_LEGENDA */
define("FIELD_LEGENDA_ID",                      "legenda_id");
define("FIELD_LEGENDA_TEKST",                   "legenda_tekst");
define("FIELD_LEGENDA_HELPTEKST",               "legenda_helptekst");
define("FIELD_LEGENDA_SYMBOOL",                 "legenda_symbool");
define("FIELD_LEGENDA_KLEUR",                   "legenda_kleur");
define("FIELD_LEGENDA_ID_LENGTH",               "10");
define("FIELD_LEGENDA_KLEUR_LENGTH",            "56");
define("FIELD_LEGENDA_TEKST_LENGTH",            "256");
define("FIELD_LEGENDA_HELPTEKST_LENGTH",        "256");
define("FIELD_LEGENDA_SYMBOOL_LENGTH",          "5");

/* TBL_LEGENDAITEM */
define("FIELD_LEGENDAITEM_ID",                  "legenda_item_id");
define("FIELD_LEGENDAITEM_KLEUR",               "legenda_item_kleur");
define("FIELD_LEGENDAITEM_TEKST",               "legenda_item_tekst");
define("FIELD_LEGENDAITEM_HELPTEKST",           "legenda_item_helptekst");
define("FIELD_LEGENDAITEM_SYMBOOL",             "legenda_item_symbool");
define("FIELD_LEGENDAITEM_ID_LENGTH",           "10");
define("FIELD_LEGENDAITEM_KLEUR_LENGTH",        "56");
define("FIELD_LEGENDAITEM_TEKST_LENGTH",        "256");
define("FIELD_LEGENDAITEM_HELPTEKST_LENGTH",    "256");
define("FIELD_LEGENDAITEM_SYMBOOL_LENGTH",      "5");

/* TBL_CONTEXT */
define("FIELD_CONTEXT_ID",                      "context_id");
define("FIELD_CONTEXT_TEKST",                   "context_tekst");
define("FIELD_CONTEXT_HELPTEKST",               "context_helptekst");
define("FIELD_CONTEXT_ID_LENGTH",               "10");
define("FIELD_CONTEXT_TEKST_LENGTH",            "150");
define("FIELD_CONTEXT_HELPTEKST_LENGTH",        "300");

/* TBL_TYPE */
define("FIELD_TYPE_ID",                         "type_id");
define("FIELD_STATUS",                          "type_status");
define("FIELD_TYPE_NAME",                       "type_naam");
define("FIELD_TYPE_DESC",                       "type_beschrijving");
define("FIELD_TYPE_HELPTEKST",                  "type_helptekst");
define("FIELD_ID_LENGTH",                       "10");
define("FIELD_TYPE_NAME_LENGTH",                "56" );
define("FIELD_TYPE_DESC_LENGTH",                "256");
define("FIELD_TYPE_HELPTEKST_LENGTH",           "256");
define("FIELD_TYPE_STATUS_LENGTH",              "56");

/* TBL_MEASURE */
define("FIELD_ID_TYPE",                      "id_type");
define("FIELD_MEASURE_ID",                   "measure_id");
define("FIELD_COURSE_ID",                    "course_id");
define("FIELD_MEASURE_TYPE_ID",              "measure_type_id");
define("FIELD_MEASURE_RESULT_TYPE_ID",       "measure_result_id");
define("FIELD_MEASURE_NAME",                 "measure_name");
define("FIELD_MEASURE_DESC",                 "measure_beschrijving");
define("FIELD_MEASURE_ADDED_DATE",           "measure_added_date");
define("LEN_STUDY_DESC",                     "256");
define("LEN_MEASURE_NAME",                   "56");
define("LEN_STUDY_NAME",                     "56");
define("ID_LEN",                             "100");

/* TBL_PRESTATIE */
define("FIELD_PRESTATIE_ID",				 "prestatie_id");
define("FIELD_PRESTATIE_DESC",		 		 "prestatie_beschrijving");
define("FIELD_PRESTATIE_NAME",				 "prestatie_name");
define("FIELD_PRESTATIE_NIVEAU",			 "niveau");
define("LEN_PRESTATIE_ID",				 "10");
define("LEN_PRESTATIE_DESC",		 		 "256");
define("LEN_PRESTATIE_NAME",				 "256");
define("LEN_PRESTATIE_NIVEAU",			 	 "1");

/* TBL_PRESTATIE_HANDELINGEN */
/* UITVOEREN*/
define("FIELD_UITVOEREN_A","uitvoeren_A");
define("FIELD_UITVOEREN_B","uitvoeren_B");
define("FIELD_UITVOEREN_C","uitvoeren_C");
define("FIELD_UITVOEREN_D","uitvoeren_D");
define("FIELD_UITVOEREN_E","uitvoeren_E");
/* BIJSTUREN */
define("FIELD_BIJSTUREN_A","bijsturen_A");
define("FIELD_BIJSTUREN_B","bijsturen_B");
define("FIELD_BIJSTUREN_C","bijsturen_C");
define("FIELD_BIJSTUREN_D","bijsturen_D");
define("FIELD_BIJSTUREN_E","bijsturen_E");
/* ORGANISEREN */
define("FIELD_ORGANISEREN_A","organiseren_A");
define("FIELD_ORGANISEREN_B","organiseren_B");
define("FIELD_ORGANISEREN_C","organiseren_C");
define("FIELD_ORGANISEREN_D","organiseren_D");
define("FIELD_ORGANISEREN_E","organiseren_E");
/* COMMUNICEREN */
define("FIELD_COMMUNICEREN_A","communiceren_A");
define("FIELD_COMMUNICEREN_B","communiceren_B");
define("FIELD_COMMUNICEREN_C","communiceren_C");
define("FIELD_COMMUNICEREN_D","communiceren_D");
define("FIELD_COMMYNICEREN_E","communiceren_E");
/* VERANTWOORDEN */
define("FIELD_VERANTWOORDEN_A","verantwoorden_A");
define("FIELD_VERANTWOORDEN_B","verantwoorden_B");
define("FIELD_VERANTWOORDEN_C","verantwoorden_C");
define("FIELD_VERANTWOORDEN_D","verantwoorden_D");
define("FIELD_VERANTWOORDEN_E","verantwoorden_E");

/* TBL_VERMOGEN_HANDELINGEN */
/* TONEN VAN INZICHT */
define("FIELD_TONEN_VAN_INZICHT_A","tonen_van_inzicht_A");
define("FIELD_TONEN_VAN_INZICHT_B","tonen_van_inzicht_B");
define("FIELD_TONEN_VAN_INZICHT_C","tonen_van_inzicht_C");
define("FIELD_TONEN_VAN_INZICHT_D","tonen_van_inzicht_D");
define("FIELD_TONEN_VAN_INZICHT_E","tonen_van_inzicht_E");
/* ORGANISEREN VAN LEREN */
define("FIELD_ORGANISEREN_VAN_LEREN_A","organiseren_van_leren_A");
define("FIELD_ORGANISEREN_VAN_LEREN_B","organiseren_van_leren_B");
define("FIELD_ORGANISEREN_VAN_LEREN_C","organiseren_van_leren_C");
define("FIELD_ORGANISEREN_VAN_LEREN_D","organiseren_van_leren_D");
define("FIELD_ORGANISEREN_VAN_LEREN_E","organiseren_van_leren_E");
/* BENUTTEN VAN BRONNEN */
define("FIELD_BENUTTEN_VAN_BRONNEN_A","benutten_van_bronnen_A");
define("FIELD_BENUTTEN_VAN_BRONNEN_B","benutten_van_bronnen_B");
define("FIELD_BENUTTEN_VAN_BRONNEN_C","benutten_van_bronnen_C");
define("FIELD_BENUTTEN_VAN_BRONNEN_D","benutten_van_bronnen_D");
define("FIELD_BENUTTEN_VAN_BRONNEN_E","benutten_van_bronnen_E");
/* VERBINDEN VAN DISCIPLINES */
define("FIELD_VERBINDEN_VAN_DISCIPLINES_A","verbinden_van_disciplines_A");
define("FIELD_VERBINDEN_VAN_DISCIPLINES_B","verbinden_van_disciplines_B");
define("FIELD_VERBINDEN_VAN_DISCIPLINES_C","verbinden_van_disciplines_C");
define("FIELD_VERBINDEN_VAN_DISCIPLINES_D","verbinden_van_disciplines_D");
define("FIELD_VERBINDEN_VAN_DISCIPLINES_E","verbinden_van_disciplines_E");
/* WAARDEREN VAN LEREN */
define("FIELD_WAARDEREN_VAN_LEREN_A","waarderen_van_leren_A");
define("FIELD_WAARDEREN_VAN_LEREN_B","waarderen_van_leren_B");
define("FIELD_WAARDEREN_VAN_LEREN_C","waarderen_van_leren_C");
define("FIELD_WAARDEREN_VAN_LEREN_D","waarderen_van_leren_D");
define("FIELD_WAARDEREN_VAN_LEREN_E","waarderen_van_leren_E");

/* HANDELINGEN LENGTH */
define("LEN_HANDELINGEN_ID","10");
define("LEN_HANDELINGEN","4");

/* TBL_VERMOGEN */
define("FIELD_VERMOGEN_ID",                              "vermogen_id");
define("FIELD_VERMOGEN_DESC",				 "vermogen_beschrijving");
define("FIELD_VERMOGEN_NAME",				 "vermogen_name");
define("FIELD_VERMOGEN_NIVEAU",				 "vermogen_niveau");
define("LEN_VERMOGEN_ID",                                "10");
define("LEN_VERMOGEN_DESC",                              "256");
define("LEN_VERMOGEN_NAME",				 "256");
define("LEN_VERMOGEN_NIVEAU",				 "1");

/* TBL_STATUS_VOLGNUMMER */
define("FIELD_STATUS_VOLGNUMMER_ID",         "status_volgnummer_id");
define("FIELD_STATUS_VOLGNUMMER_NAME",       "status_volgnummer_name");
define("FIELD_STATUS_VOLGNUMMER_DESC",       "status_volgnummer_desc");
define("LEN_STATUS_VOLGNUMMER_ID",           "10");
define("LEN_STATUS_VOLGNUMMER_NAME",         "56");
define("LEN_STATUS_VOLGNUMMER_DESC",         "256");
define("FIELD_STATUS_VOLGNUMMER_ADDED_DATE", "status_volgnummer_added_date");

/* TBL_LEGENDA 
define("FIELD_LEGENDA_ID",                      "legenda_id");
define("FIELD_LEGENDA_TEKST",                   "legenda_tekst");
define("FIELD_LEGENDA_HELPTEKST",               "legenda_helptekst");
define("FIELD_LEGENDA_SYMBOOL",                 "legenda_symbool");
define("FIELD_LEGENDA_KLEUR",                   "legenda_kleur");
define("FIELD_LEGENDA_ID_LENGTH",               "10");
define("FIELD_LEGENDA_KLEUR_LENGTH",            "56");
define("FIELD_LEGENDA_TEKST_LENGTH",            "256");
define("FIELD_LEGENDA_HELPTEKST_LENGTH",        "256");
define("FIELD_LEGENDA_SYMBOOL_LENGTH",          "5");
*/

/* TBL_COMPLEXITEIT */
define("FIELD_COMPLEXITEIT_ID",                 "complexiteit_id");
define("FIELD_COMPLEXITEIT_TEKST",              "complexiteit_tekst");
define("FIELD_COMPLEXITEIT_HELPTEKST",          "complexiteit_helptekst");
define("FIELD_COMPLEXITEIT_ID_LENGTH",          "10");
define("FIELD_COMPLEXITEIT_TEKST_LENGTH",       "150");
define("FIELD_COMPLEXITEIT_HELPTEKST_LENGTH",   "300");

/* TBL_CONTEXT */
define("FIELD_INDICATOR_ID",                    "indicator_id");
define("FIELD_INDICATOR_TEKST",                 "indicator_tekst");
define("FIELD_INDICATOR_ID_LENGTH",             "10");
define("FIELD_INDICATOR_TEKST_LENGTH",          "150");

define("TXT_ERROR_CANT_CREATE_TABLE",           "Kan tabel niet maken.");
define("TEXT_CLASS_MISSING_VARS_FOR_SAVE",      "Mist variabelen om op te slaan.");
define("TXT_ERROR_DUPLICATE_ENTRY",             "Deze entry bestaat al.");
define("CLASS_VARS_MANDATORY_ONLY",             "mandatory only");
define("CLASS_VARS_ALL",                        "all vars");
?>